package fun.rockchen.dao;

import fun.rockchen.bean.NotificationEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Rock Chen
 * @Description:
 * @date 2023/10/21 20:13
 */

@Mapper
public interface NotificationDao {

    @Select("select userId, taskContent from task inner join userMapTask on task.id = userMapTask.taskId where DATE_FORMAT( startTime, '%Y-%m-%d %H:%i' )  like concat('%','${time}','%'); ")
    List<NotificationEntity> getStatusChangeTask(String time);
}
